FO_IF_Path_XRef

This table contains records which are cross references between STUB order and data required by Pathology system for case number assignment.

The table can also be used in translating FAST orders to RRE orders for Pathology.

 

Field Type Notes

Path_If_Xref_ID

int

ID field, a counter. Unique

TestCode

varchar(50)

Enter a valid FAST order code for pathology.

PerfLabCode

varchar(50)

Enter a valid performing lab code.

LabDept

varchar(50)

Enter a valid lab department as identified in FO_Tests for pathology orders.

PathDepartment

varchar(50)

Pathology sub-department, used in creating pathology case number in pathology system.

TestPartType

varchar(50)

Part type required by the pathology system.

PathDepartmentName

varchar(80)

Pathology department name.